﻿/*
#------------------------------------------------------------------------------
#-- View Name:		[dbo].[vwWH_LogCheckdb]
#-- Purpose:		Provides a method for reviewing checkdb failures
#--	Last Update:	03/22/2013
#--					For a complete history - please review comments in SVN
#------------------------------------------------------------------------------
*/
CREATE VIEW [dbo].[vwWH_LogCheckDb]
AS

SELECT		ssd.ssd_sqlserver_name_ro,
			mnt.mnt_table_catalog,
			mnt.mnt_action_date,
			mnt.mnt_action_type,
			mnt.mnt_success,
			mnt.mnt_results
FROM		[dbo].[tblWH_Log] mnt (NOLOCK)
JOIN		[dbo].[tblMSX_server_discovery] ssd ON mnt.mnt_server_ssd_id = ssd.ssd_id
WHERE		mnt.mnt_action_type = 'checkdb'
